// 云函数入口文件
const cloud = require('wx-server-sdk')

cloud.init({ env: cloud.DYNAMIC_CURRENT_ENV }) // 使用当前云环境

// 云函数入口函数
exports.main = async (event) => {
  // const {detailsId,proId} = event
  // const db = cloud.database()
  // const detailsRes = await db.collection('details').doc(detailsId).get()
  // const productRes = await db.collection('products').doc(proId).get()
  //优化处理方案：根据当前产品id获取所有的产品数据
  const {proId} = event
  const db = cloud.database()
  const $ = db.command.aggregate
  const data = await db.collection('products').aggregate().lookup({
    from:"details",//被连接的集合
    localField:"detailsid",
    foreignField:"_id",
    as:"list"
  }).match({
    "_id":proId
  }).replaceRoot({
    newRoot:$.mergeObjects([$.arrayElemAt(['$list',0],'$$ROOT')])
  }).project({
    list:0
  }).end()
  return data.list[0]
}